set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'mov_getDirectorListing' AND type = 'P') DROP PROCEDURE mov_getDirectorListing
GO



-- =============================================
-- Modified:    Sourov Chatterjee
-- Create date: 6/3/2011
-- Description:	This procedure gets director listings

-- =============================================
CREATE PROCEDURE [dbo].[mov_getDirectorListing] 	

AS
BEGIN

	SELECT movie_dir_ID, movie_dir_fname + ' ' + movie_dir_lname as movie_dir_name, movie_dir_fname,movie_dir_lname 
    FROM Movie_director
    order by movie_dir_fname
	

END


